Analysing Movie Data using SQL

The MavenMovies database to inform insurance underwriters about policy renewal. The SQL queries developed offered insights into inventory, customer demographics, staff details, and financial metrics, essential for assessing business operations and associated risks. The analysis aimed to provide a detailed overview of staff, inventory counts per store, active customer numbers, potential data breach liabilities, film diversity, replacement costs, fraud prevention measures, and customer engagement levels. This comprehensive data collection and analysis facilitated informed decision-making regarding insurance coverage and premiums, showcasing the practical application of SQL in business analytics.